SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267293 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267293 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363320,893107,630410,540975,401299,135468,560939,447010,440687,820096,914222,287412,773230,980344,40925,597398,828310,754177,593002,19951,992208,261743,206009,178002,724137,104842,474630,717435,408795,423583,636450,225770,760848,808000,568678,266524,97713,53646,693175,296565,598753,749014,921660,159233,232908,138613,33756,721991,201902,649005,551861,599863,224057,712000,536642,714683,343809,708049,545449,745871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]