SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559402 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559402 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347410,937658,893360,713762,371111,604204,554024,870341,158321,360657,221840,179780,911298,435678,904687,850017,186035,268423,858769,543965,899676,869888,890168,20782,726151,551257,978341,539352,535474,642568,815969,580570,138262,142473,775318,60980,962978,1042302,16384,704953,690840,560377,465275,591706,671291,715637,614780,739040,846071,789657,572492,863952,750519,37052,5560,924487,614769,34906,540831,73657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000891s ]