SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026001 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026001 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894387,177805,336432,460302,1627,880417,414029,898532,62730,750528,398015,335035,228070,22421,991532,43960,756252,882035,59891,390505,994242,704761,907078,576664,57519,456196,44248,123556,441651,128692,692143,306791,281535,805922,809939,614171,580760,500425,963352,635907,726036,694109,250420,974673,363467,490661,655066,575269,451760,90670,342186,739429,562238,982786,1015932,479747,437368,142033,773399,148923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]