SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318146 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318146 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362106,485098,153329,677206,951083,641091,469541,644630,194013,487400,506957,168845,289785,1009770,421425,896521,374795,1027224,185043,241243,94459,640544,229222,787524,945483,266530,595158,93045,386804,14319,672381,843410,122509,711411,471500,783386,841828,338999,592686,638578,604693,216985,683726,338931,47566,534033,650636,551942,550118,193207,645608,353243,254230,808013,1001033,133804,323192,390487,4497,162581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]