SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424508 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424508 [ RunTime:0.002974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222019,725303,82974,996319,926215,483905,89784,98183,1013371,51675,507719,946797,809189,226298,67805,618876,337463,860775,352586,182901,604502,361693,1026670,338036,926197,940305,1016901,182958,471437,297011,621854,402985,311832,295215,348212,1009966,723760,634277,411725,986026,936254,156269,322669,21473,176110,166634,1014679,794817,174150,532879,707883,291633,393074,109702,827473,607537,372803,440024,546965,31712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]