SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483275 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483275 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42295,467970,391264,321877,22366,440126,606717,376064,899803,592142,680135,530130,748190,1026574,391321,61369,765003,959683,94364,57452,824479,234045,298983,279487,135238,375902,1045734,904422,759994,770656,10347,510817,425966,948741,249678,864474,2875,1029889,636733,606642,68318,417844,1027736,806690,246851,488054,179072,706114,365213,284887,245675,594965,211508,840273,434091,444725,368958,1025260,886924,841583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]