SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570295 LIMIT 1 [ RunTime:0.000697s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570295 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109581,154460,390354,324984,389353,732103,596351,865613,935232,840515,663160,255570,791441,684212,18590,736954,795044,268350,397539,146400,292204,679605,298240,507078,731654,876571,745678,754363,241191,259840,470598,245646,407759,836053,1999,288944,751873,19948,32739,682895,347677,961379,871274,119460,463266,152505,989728,777408,695950,370781,753524,823585,655331,414071,184471,683851,384857,23918,985924,151350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]