SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547576 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547576 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564987,989810,708265,949840,968025,760231,46837,578153,358492,415913,459115,385202,182640,582896,236573,489535,644877,479506,35637,949347,811623,741259,417954,881071,486482,504384,1017345,71773,526556,965014,735553,289726,688567,85715,525398,672444,598202,271457,521322,359502,68760,944406,319455,167774,827538,581372,64144,328072,528271,71515,409780,186753,504338,767309,918726,684077,331203,549909,445465,286432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]