SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010264 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010264 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531341,801436,820328,329279,794976,101627,764585,834676,86698,681284,862121,455848,855758,712190,947602,412820,419737,924791,733363,712196,232466,54783,611561,393399,400073,307498,42478,439214,809351,880069,123766,819138,189507,268252,574599,825761,268195,248153,568487,970436,70396,359315,832662,234183,149617,327124,247617,587849,170324,214773,557893,663218,337968,1019197,526637,1008938,212052,922546,400115,564529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]