SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100523 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100523 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040546,294478,961767,218651,877896,431870,1024262,1037677,751096,107532,751595,207338,888671,853986,9738,149903,692803,999123,240068,611486,880148,1002945,457476,656157,905966,490931,100330,93070,158640,271522,263304,324180,983684,182836,733067,817926,820618,905265,505558,936818,766068,538221,454987,22794,884316,192415,7576,623592,799961,923113,529023,980061,1003327,699499,18615,52439,874647,122394,247427,921932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]