SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285913 LIMIT 1 [ RunTime:0.001139s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285913 [ RunTime:0.003417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63527,468089,319207,534947,625439,295017,817195,750512,185250,1039474,1488,143016,156001,309235,620102,269681,488974,156793,257218,1044911,688392,82600,346051,1007988,198514,453589,708309,1048221,556609,295577,72988,949051,580805,709954,498981,693413,431162,827660,765837,357125,439945,396856,736645,665773,887858,971979,488401,102832,19302,611456,163018,448276,330029,381294,669687,975478,922815,651973,620733,898001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]