SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016883 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016883 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874254,863585,929826,691501,759705,242789,533956,772942,827603,833888,702061,59672,315356,291664,127640,959822,941277,346766,51599,759774,239891,978487,401472,414610,490406,224682,775580,432768,766604,730012,650612,829550,246093,485859,473844,1005141,362583,726370,545497,616741,680027,1005481,19655,803337,705337,547872,683198,294689,330701,96415,717717,103324,101120,988834,209067,676352,644593,1043749,747945,511866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]