SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211099 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211099 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176950,129988,616416,68968,5297,519213,116518,1002178,842193,50955,775877,46198,189439,69003,527878,233982,43222,555556,109678,761042,736808,663102,304576,870112,561987,54099,322200,800426,991052,265532,515513,195562,607166,639476,117718,113992,1043786,440867,349783,313050,232206,647424,1000173,1015360,899802,513546,757110,656469,741193,118180,148934,72748,820909,414014,203356,965851,145206,384764,930450,1022053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]