SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416950 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416950 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288251,622719,541888,447260,340476,920183,746543,838067,411582,597231,380595,252529,660516,578989,801696,190202,156580,97314,96495,634989,901478,121411,722084,323198,178021,640594,428128,164911,159537,187692,140444,862069,460965,785749,160623,15134,389005,6913,480467,714906,12748,812212,299878,135016,765196,815875,499032,152466,190161,386322,364197,62995,942939,863874,511741,414102,152681,357382,649888,312774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]