SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453573 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453573 [ RunTime:0.002702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039522,98736,617303,841146,1005233,243654,274549,426080,75365,602487,539732,426900,281232,637167,718616,618493,567405,918323,1033231,27152,638564,485375,832158,256384,37039,704735,732006,855184,137099,270139,43135,16240,637255,815238,491315,445424,99517,320963,87035,881747,330972,915897,42755,270623,506105,822195,936945,166179,1002325,606275,1037482,570890,573500,299564,961147,408074,922002,347956,670904,783244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]