SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28158 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28158 [ RunTime:0.003626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76859,685010,241009,451381,1024439,199115,200980,259500,830607,233000,308584,261302,485439,26309,371132,567992,846563,348934,952006,28040,984565,327321,402277,40460,1036304,917387,714246,969305,430527,477684,231861,565215,369203,384949,204883,935793,449033,140700,721870,353580,275571,11225,260677,765452,883566,865660,526898,905923,955402,48690,847773,972594,696772,196098,638442,999693,948173,785547,345860,1016212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]