SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023854 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023854 [ RunTime:0.003039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285488,1037857,501748,961991,32506,217933,479550,881974,476892,978240,454502,685179,957634,506291,661539,852781,287889,400257,219892,1046412,667034,921708,657101,94855,435725,283286,1024949,495401,677089,811914,786340,802711,794081,644070,378711,121616,1009394,1046413,395549,300686,454461,262724,885033,916414,299681,708745,516662,735304,452688,75073,1019183,351861,105164,455325,70200,267581,512714,394153,889357,654489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]