SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336853 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336853 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295916,276152,320225,355112,221077,542864,433132,686318,146528,836963,189881,897691,173445,14911,104690,200180,780031,520351,898160,607748,148278,65380,167134,397678,561659,1041142,312093,929186,865805,952875,447199,96769,531357,350695,917091,10388,1037116,350299,160915,940204,671459,664435,1028723,142019,931883,76641,46003,599979,921719,145172,848822,774964,138075,732322,858745,57896,241006,870960,709736,732702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]