SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299640 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299640 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521640,464531,706094,941327,509683,809448,461404,846176,254514,956102,441472,628740,847918,902838,277429,219562,337264,973671,525699,946970,245936,481829,41897,1023703,781364,956839,16563,317338,286750,146429,268126,815105,1018131,921548,546716,747984,1046082,98092,425186,65459,88395,399702,982303,469268,197740,174140,370148,537003,872759,831793,69037,703522,77202,392423,607205,682231,459376,949710,115792,322135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]