SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520234 LIMIT 1 [ RunTime:0.001629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520234 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358006,353293,255489,265164,761820,612133,771769,1018702,356174,1002929,569850,929465,532993,324555,578395,764757,578947,69727,905604,12557,420449,145908,531870,954075,860652,67383,645183,75464,237275,371767,233383,1014895,159293,418539,292929,777798,228972,692499,364943,564670,387978,631917,190093,177118,354598,795037,248307,217322,320347,371570,776722,962688,967242,819804,335027,201559,25765,390206,813594,348330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]