SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142976 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142976 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289244,130767,734003,288987,374170,7017,823078,419343,659789,636995,667157,714513,254689,600750,889490,116991,281897,758509,201092,305227,788867,212458,667847,341209,763347,233882,729176,880835,123226,196148,568142,881122,1022829,139142,385727,289991,850885,20254,716531,790189,651909,1021315,397447,25616,555123,540021,856557,938758,977833,369123,43375,253415,39162,173451,64466,732397,213397,600582,255051,129977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]