SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429440 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429440 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916222,190982,352217,670627,145253,274927,202626,762325,125050,661061,124349,469204,263584,159642,54094,339017,416312,233196,686174,487932,643394,1002772,661328,354500,926700,805686,24211,19088,469795,196670,774543,794784,346402,180171,190193,635304,993010,134924,421885,1042520,170580,585242,46636,622501,292096,922267,868866,826754,47886,900962,906636,503581,204328,185026,929905,51008,687204,458603,371356,629858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]