SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477317 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477317 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781610,303774,1024871,358111,23295,635215,109846,183908,172657,397969,803956,190582,519974,48900,293647,44429,154357,141435,548458,749658,158808,1025998,142495,93577,194484,408026,558475,175815,733660,99582,166912,442987,965718,230355,360810,84149,376825,15253,58064,806377,875421,320572,187679,555833,1010240,363962,946682,845762,362310,172659,316069,790474,226329,718190,905603,749497,466156,303112,315103,829130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]