SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314915 LIMIT 1 [ RunTime:0.005898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314915 [ RunTime:0.009729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24226,771576,664047,398063,840499,27314,878614,46435,578395,1023597,70715,581772,712183,26434,295528,165730,118547,817992,679967,345080,53100,455009,22149,501892,1017043,513940,402284,212491,762752,460510,348033,173544,910765,648201,988947,173843,491382,262019,933244,135110,30264,1005405,522807,804427,925249,1004517,957093,581708,744178,267535,348300,353436,701127,442925,957803,143338,320980,553232,84976,503455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]