SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502876 LIMIT 1 [ RunTime:0.001334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502876 [ RunTime:0.003221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219760,172633,660491,720308,726405,850353,785436,1004092,618226,26039,516094,155824,204501,166854,983870,567044,617963,38067,586184,173945,73509,443311,873395,766554,879269,108699,472583,44501,615350,753383,457104,979487,360267,594076,721483,61710,137061,899885,301321,310376,210326,384761,1002461,995656,1025074,313582,237800,383818,503398,819661,253785,11755,250006,341605,685068,639812,96360,518063,639922,68134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]