SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545479 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545479 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118561,806808,67935,72541,515304,103014,829752,352591,341383,702862,125335,363454,839193,307595,602929,850860,1014838,594075,1039735,272504,695226,130211,177622,24099,211621,240776,948186,482792,40245,691487,828554,651048,455638,752821,830041,135805,98829,510254,495538,752919,140677,336282,813762,274855,480889,547167,184050,793344,699551,137257,1035176,917044,412155,67313,889981,182414,16569,779998,47645,502343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]