SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505906 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505906 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933140,848577,984728,48626,356610,748394,698612,199902,969105,99309,194811,390364,276451,697786,417229,438791,346471,562116,26505,764302,640405,398056,815142,318309,840917,367938,863824,633550,489243,447896,747428,266128,366047,426994,407815,140514,431297,631861,617405,743835,73856,528389,122024,819160,757800,260841,74074,28332,438243,818258,862208,455133,575865,548082,258006,462361,300800,718274,307582,765116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]