SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407987 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407987 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555113,408730,209106,696929,201742,1006735,97587,904254,422483,236909,620303,796452,526715,490079,121019,134788,405667,541961,200507,1038824,537479,45895,784195,940101,17065,613620,272570,165179,714133,411748,973371,299915,681167,118101,876467,990865,1020920,690690,731973,806843,302455,883934,58181,127318,195458,60761,421244,244826,998128,411101,667333,855004,348678,394135,455077,996177,393416,753636,547070,924323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]