SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324013 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324013 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926489,812360,198822,85286,1044236,228654,619461,813919,333366,601683,16685,331187,341585,873741,393447,26203,726360,822334,3598,1000083,656353,184084,511624,230890,424368,652800,17511,581022,894131,1020538,151553,360181,499349,691625,98322,200814,949259,312692,990727,333328,460800,564589,329825,718926,515644,909699,30375,259862,907737,464491,406083,299347,870605,951238,46189,431924,574230,1010283,473188,278994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]