SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482495 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482495 [ RunTime:0.002023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354040,12544,338089,592321,614166,421306,917056,264605,235174,1021755,171942,319822,458390,826050,1042336,1000561,180246,1022182,140010,182779,935658,152284,789493,215918,951422,174989,39540,291470,972557,262728,260760,26872,804391,775576,1013338,1029214,637891,201350,124875,40418,474057,257102,359617,479176,919906,20651,112640,990743,238139,188704,33181,761709,387902,1018432,408302,758588,661697,455465,169900,97656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]