SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54366 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54366 [ RunTime:0.002875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419184,947123,309594,915006,784397,773556,195392,552156,464931,694464,361172,878998,396768,339871,1032628,979069,293169,104490,838892,824810,826595,643299,887646,220612,797758,511392,530835,929419,110711,992378,477375,528317,375082,33886,662196,515475,875068,275072,754115,516765,373180,270235,39668,373245,822604,199077,1011225,593400,888296,75376,944421,229093,105693,198671,256956,35705,426134,430275,325023,491279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]