SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 762382 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 762382 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524826,848062,378609,511819,602560,106937,287674,1029393,801884,891484,82101,353075,473560,254040,491727,381182,947777,389008,86970,62966,693501,856485,467483,921983,580653,185664,186897,526339,947176,480291,327043,565180,773449,518741,502522,306027,771781,372290,63685,990180,493501,308238,661552,384138,266349,1536,658924,750010,733259,712832,352918,340339,425593,153137,86964,641747,16054,679103,615701,849530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 762382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 762382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]