SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529428 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529428 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359036,736633,839173,1037998,689504,393647,96137,403917,26043,984093,630980,467199,486709,101815,377315,889199,579982,574459,241143,503111,297654,56538,78132,590767,395286,401721,526909,175285,258417,615492,631878,790859,24775,487148,291626,367280,533868,116585,674057,844438,22709,266566,474691,1048644,205280,346823,267736,968868,480534,897885,461257,395488,668501,182245,432330,525745,49220,708727,976850,214985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004720s ]