SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410623 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410623 [ RunTime:0.002900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729293,881532,557491,814049,892756,409959,323632,800879,859807,581694,201947,786132,95697,197400,747656,864077,394216,329841,830244,339885,97309,893968,202114,439052,221961,615306,155705,240998,566908,209355,809804,494676,180201,787799,576018,530958,889103,903966,66689,692584,256665,653372,354495,1031068,474117,212594,935349,450414,884063,718672,146187,418695,983083,799422,769904,186997,418323,631728,758288,183048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001276s ]