SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004371 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004371 [ RunTime:0.003058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850156,519236,925363,381265,1037898,207060,988117,501139,312004,658695,988020,579979,518206,133007,580293,352228,362953,889103,882614,361097,958269,142509,977298,441071,887583,593013,827768,783130,101955,199577,652916,759198,610660,281062,1033814,108529,71729,829545,203479,715177,957551,73580,273225,693332,932975,722985,414080,232533,809026,640992,228340,708370,565642,311065,799796,784180,582928,346498,660632,1024385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]