SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027202 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027202 [ RunTime:0.003209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678273,820924,233932,67369,283801,411882,972506,409915,617148,575120,783969,534625,881534,229934,932014,292314,930892,987356,254343,224875,521559,560720,612953,969906,437955,162939,1023255,634178,50757,160380,318229,856656,123446,652937,563724,599034,102992,177425,587503,606734,253684,655868,349580,643461,123292,73838,325650,263075,417572,654517,781322,634514,945653,886236,205993,977469,401439,101293,904072,492729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]