SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28714 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28714 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520457,560818,426708,953779,190413,486598,855948,672450,46704,331991,325856,808742,744017,270337,554798,207036,351723,262266,413305,20225,589455,657953,559180,398746,791081,697663,396114,435297,915225,1043678,779746,1034575,999161,1026134,834994,953706,108614,80360,671197,812830,222,471038,738237,603973,709263,629810,50126,629545,626898,837648,491399,201403,413784,495313,792606,673506,302681,283,528682,3544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]