SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402041 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402041 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76761,710878,333995,852765,1035000,77665,307179,309396,712580,293270,404430,131515,876091,1040971,297766,760897,387249,492218,393968,336658,200812,756097,781657,1042730,653443,431797,997703,195354,678633,131346,407803,359767,985589,368337,1015781,229520,131285,46185,127055,393806,956751,919892,600269,795849,53054,391394,191617,167783,40031,384628,681305,65411,196900,406804,1001293,755294,787950,818372,110986,1024006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]