SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397413 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397413 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752054,696688,287541,491038,716545,897248,751992,503766,38580,288825,416486,819328,871312,609428,542878,963649,426493,797643,501023,467501,891504,699423,381093,571536,677917,309030,222025,788578,1014530,549561,780656,699578,363720,591774,390191,97947,623492,468917,544527,1025484,49254,882886,68867,143280,359580,165229,693079,402057,198648,1005500,565595,769,789530,634929,27232,891573,599760,331316,298756,792981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001640s ]