SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293054 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293054 [ RunTime:0.003691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821448,445080,335692,188168,644124,924483,797966,661081,415246,146014,94712,1005300,414145,1024380,291854,826776,914549,621847,96197,552432,411545,561295,386034,749529,504399,840412,567548,67827,182185,149646,902375,488656,612368,1006191,951445,448144,853381,106359,100845,673783,606520,887167,905808,340748,276377,554951,591093,331012,860295,34253,238060,391108,927591,601923,437353,258644,707916,1034312,138646,470439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000734s ]