SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452343 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452343 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899290,21974,14600,734642,357931,997364,123670,113626,912569,534521,429676,49493,63149,960773,235026,261135,791727,640582,673788,199097,1042074,284274,970892,994847,28107,288394,213708,945095,661476,973904,519912,546669,671065,307407,911275,398720,996438,441704,455396,220105,499839,869649,813538,378641,716477,814653,501563,515320,128650,19592,86264,63930,1015033,931687,722082,200886,508619,178630,71948,29791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]