SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808003 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808003 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541491,472035,1021843,545373,42551,386387,976502,169465,1003277,156079,432645,465417,673532,535593,640613,879626,1019730,12262,115798,571915,455161,219021,986161,900832,269983,552957,212994,230544,154720,615812,398472,720577,806651,264789,482506,998172,381395,29961,76554,163872,768547,958684,168709,292881,997974,809981,573032,589655,841708,193035,589992,437081,335615,1006905,508612,118993,797863,197840,207931,447757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001628s ]