SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395216 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395216 [ RunTime:0.006839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418811,841428,676376,420459,437455,912320,858253,597003,366749,544479,34578,29210,481798,159983,312762,251555,629022,222725,611582,40044,803455,756752,499737,18780,639520,752156,559092,106512,51018,523499,452425,634499,619208,174680,517704,196663,687103,67789,831869,59223,520758,532846,985548,988951,4375,1040108,309619,481824,963675,676375,789746,378162,989863,251785,870431,260912,794552,147923,333706,576838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000870s ]