SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509609 LIMIT 1 [ RunTime:0.004663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509609 [ RunTime:0.007640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150737,573388,341180,782694,232633,224324,218501,530130,341419,914280,298035,37790,828923,106293,942202,113792,113417,710317,963745,900441,67628,666528,131824,614063,214510,682412,475724,558815,462456,135414,239019,957509,212036,178717,195640,364478,1039678,317077,427655,4744,474824,224199,682509,666903,90970,348284,807533,72570,3745,358736,979710,890831,762448,747339,710688,527407,556980,832674,1968,892074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001763s ]