SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532051 LIMIT 1 [ RunTime:0.001246s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532051 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318214,671423,285259,172498,761572,431186,485344,954822,931126,985712,178827,694455,811363,620406,736948,20139,948300,684150,331528,448717,828911,936727,697267,532844,676061,585097,839566,1047803,968275,999284,81650,244312,714327,602122,100150,937140,539617,317750,753984,123236,355682,249605,829646,791466,537008,470979,653888,168111,955415,96522,478556,610625,122689,269399,676817,285263,343876,1007878,944877,667758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]