SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343147 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343147 [ RunTime:0.003462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047576,245536,120480,453984,438174,799203,543764,246617,265044,940043,124675,558955,970414,842577,416305,356480,454543,165062,421273,1022159,208241,293216,209081,95837,118278,983477,225785,249014,777481,865393,503076,83793,842932,821093,297048,737630,583810,913808,44861,10206,273054,566417,693089,176332,910328,147852,527514,115988,117664,71259,459342,273092,737443,737488,916396,824563,129512,448689,436836,203342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]