SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109718 LIMIT 1 [ RunTime:0.002264s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109718 [ RunTime:0.007175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166653,629798,133556,963506,590685,737440,720847,600186,776733,980691,911521,811794,717187,1002420,220703,1014358,568651,627415,43188,432438,134330,114906,944151,927379,241970,27106,895044,634130,863744,351454,417658,462735,283007,779020,612214,934418,185543,348519,600769,858092,502405,945065,1029832,1020720,405253,60373,956298,455145,971822,467362,960013,1028038,347827,230314,169577,53384,1029240,261926,1008377,612018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]