SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292207 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292207 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289472,199479,868755,758153,712077,487761,50914,574637,276220,604969,517433,304150,496736,606597,400243,21099,651920,261154,703857,672217,74982,711821,569642,899015,258342,1020893,600708,642357,753260,326699,942278,1027043,780991,898897,521270,671809,214618,343331,94576,565950,485249,708845,483432,86456,47282,555548,747005,162174,219816,101879,404484,3166,810293,151626,809350,160914,727742,759221,417173,374440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]