SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50109 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50109 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942633,711738,893050,296499,295586,893811,351282,1002176,282209,614208,902834,507750,285571,970637,770254,233162,943677,997752,950870,686510,612706,365025,22618,549244,488320,720472,724459,248249,648347,704101,788124,862891,808394,20126,716643,838996,642148,60087,328952,109724,35387,863862,868153,53650,353286,230490,470932,141841,322011,152653,419141,911525,213578,809352,333522,269868,379203,661483,843485,505835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]