SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802496 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802496 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240942,23755,200121,617983,381387,489367,644657,949720,928213,58443,462415,180575,207659,512185,355701,250072,846476,944027,320868,867974,924414,79431,241420,779480,960884,295564,238765,747231,403315,195233,986498,242727,329987,451834,388334,738905,652535,570161,413285,564721,263648,702723,871064,955984,966634,442980,474230,871042,900083,145727,945832,713697,163415,137676,957332,523178,951406,647886,769297,753024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001208s ]