SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282210 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282210 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654172,580130,596780,203538,543044,727733,903794,1042654,321121,808150,376028,730381,5646,697212,181204,968032,970101,60781,288867,736621,899184,1046150,858933,526691,660071,573420,672988,551712,546129,135251,294263,215200,708089,266089,837150,820812,941172,549673,510113,70204,465531,992539,516697,616673,216387,397952,961627,1048617,976879,911749,668025,411569,484023,68416,997262,97533,862252,347297,520245,722350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]