SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467331 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467331 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652197,780922,843757,620980,340993,53012,691892,532526,816008,720685,335562,642113,97936,684819,13494,371869,427432,620143,696404,472751,219944,948922,734648,689902,864650,487346,968663,946873,402389,748065,765568,15972,668319,42145,986151,55641,130204,79711,1012160,432036,489812,708138,407737,282810,26542,445927,732473,68720,146984,896741,563638,172573,410494,575003,488913,694970,370334,493174,533449,977651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]