SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419658 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419658 [ RunTime:0.002880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201553,573001,933611,937085,986097,725508,588806,129883,854036,488111,1010557,570022,320775,233662,1018180,590960,652814,838345,745931,498120,1027234,51417,109531,850170,680013,1000495,198330,333820,1034436,1037497,965314,156629,204104,679637,748716,393756,114874,994909,442813,820940,44495,983059,784487,348104,489131,194397,695676,941364,749914,771354,726843,337844,228453,391502,720589,719643,761108,645586,651982,408363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001040s ]