SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143923 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143923 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532423,126251,849338,601022,919353,214318,358442,155419,452053,263998,405735,553881,561285,708102,679907,19109,149488,1018265,982990,4988,873620,327431,228883,559038,266798,227971,95851,962981,147767,16151,96508,37961,687220,599712,608447,844913,113817,66994,382078,375812,864208,180878,187405,521531,1004564,784590,758175,78537,933545,185454,270893,383646,409993,810321,1034580,161926,11799,730541,23618,380965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]