SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539398 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539398 [ RunTime:0.004339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284788,438968,851420,414193,371492,72039,682642,734102,294126,948668,695760,128475,690429,665672,556281,620122,150904,760424,889955,712465,537735,466483,754678,435978,1035521,703188,807608,609946,768133,126955,937222,1027420,653186,508489,160037,680714,704501,953415,447426,269172,438792,539674,206205,428259,491538,47531,895995,876469,323706,144538,885656,1784,448921,94026,329558,278058,922880,80134,916466,341697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]