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` = 1027705 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027705 [ RunTime:0.002952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567287,1044694,233219,887949,157516,914814,739199,285261,987808,10848,767476,905177,256212,561342,39735,290080,757713,428688,1012305,1022266,394357,546909,841296,350005,200000,102037,1027800,919630,809305,827503,365119,328301,980339,920926,178813,1011303,868022,729225,815539,44814,960390,331689,819859,360111,155716,919161,195795,719180,1018082,391144,602822,470251,723103,231144,787178,1030251,354396,500179,701967,833714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]