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` = 801581 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801581 [ RunTime:0.002338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684224,199931,23592,689325,307129,1032714,748391,640025,225706,366433,123198,171787,425019,953406,147485,640121,370657,487045,249941,1028525,259531,798753,598961,33484,468424,625466,173825,647344,686466,645071,858322,509764,948689,329397,897617,708036,574144,956216,966103,158491,991174,87667,540079,592040,947881,648915,543394,447278,785391,339860,446053,904716,632788,619248,622014,351798,885544,409259,784003,419870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]