SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584457 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584457 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24553,988712,354599,817386,348874,734110,287073,960771,555891,16253,584720,639015,16776,388625,819606,140157,357426,834522,678061,538561,931914,777799,365202,689079,786465,288074,301129,644240,810282,517387,487410,832969,17136,222819,91664,973045,228837,10627,173028,257324,447587,974408,95012,202383,15515,313382,855441,541701,65065,374738,1019231,45615,247743,12297,791776,945989,202571,508690,482758,544469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]