SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391570 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391570 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439657,891939,950311,517858,1040448,624996,68720,703759,509861,2016,790452,658062,117012,178644,138484,998787,468108,949872,75630,831327,981439,765414,991382,292412,240463,86689,633685,150344,123618,100639,667660,876331,470570,266811,340139,415229,794449,324188,588263,184560,224780,864776,358924,660144,424082,854627,369903,536767,1025331,897299,375761,729368,682331,387916,372139,553568,60208,179839,306579,875253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]