SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241211 LIMIT 1 [ RunTime:0.002158s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241211 [ RunTime:0.002369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483625,373146,999797,871195,949547,866301,173650,285071,987918,310431,491282,417080,202912,750991,762694,126924,1012257,1026162,322326,226149,928877,1035580,587048,538189,17146,622317,782065,603497,354090,830132,1028217,614941,1028503,850031,961099,97794,174531,728558,398425,298929,712788,860861,681668,409388,424082,923595,441319,615775,999181,153646,206289,296788,684261,200629,117623,718793,283340,106367,15986,934207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]