SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407935 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407935 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298053,511128,487639,191559,174861,62131,829698,268039,207478,608406,696440,63260,381573,557333,131366,274132,388395,886941,880787,277276,871183,278871,293221,91375,489416,58389,218223,544188,731727,396367,955830,357685,744108,139091,172720,1022233,832046,104258,563291,38670,323367,238384,22471,123190,94861,512775,632973,570307,333532,895971,1025308,777565,448211,954952,446328,480123,309485,613481,77745,212959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]