SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245316 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245316 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840065,75516,1021059,63161,700416,759984,785019,392444,173176,964240,1016387,943356,633580,847252,628639,14529,826815,206688,276573,435841,419457,152239,411229,260116,941697,461636,24834,1009460,269811,983864,805843,493774,13807,515605,1043490,534394,716121,425737,869634,1005563,288921,459821,529717,723183,112115,510059,467427,282364,224931,568106,530462,735883,744578,864970,147116,538681,329763,187243,568223,403050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]