SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407434 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407434 [ RunTime:0.001376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280335,427971,715726,964826,385089,286760,492914,998742,952868,661090,294063,858657,361470,214771,606172,15581,253315,582959,380384,851053,1013059,829357,919861,571393,776648,351205,670446,34795,260425,70810,870365,1026213,827748,122232,1030358,444197,211554,444225,898943,213691,570316,817119,936969,321701,507870,261768,449810,849315,282910,892923,337574,645465,259227,662976,253222,959038,227584,190716,764742,331693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]