SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491800 LIMIT 1 [ RunTime:0.000651s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491800 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533306,636145,111295,609266,895028,939184,206792,319745,618938,448668,657552,29831,485751,1044570,224972,593168,663062,594661,448104,59822,318497,197241,590761,90915,807736,170704,722506,186696,648683,291509,510366,446212,21348,876719,420582,98694,552386,934038,908476,782480,401854,203953,637845,695959,361137,576772,787679,713619,242629,237025,327971,970229,799651,922678,500767,795655,836445,1023362,157942,648918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]