SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189913 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189913 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489625,478879,716636,401768,588178,341680,724043,652245,735349,645770,990926,635029,3826,1029890,574011,94585,1045920,249722,744202,192238,721021,411244,460206,196270,977517,107615,239468,901134,718741,111153,947100,829968,738744,919879,116754,789306,276026,1028371,1003688,502091,806036,700917,896353,154849,180742,346523,911902,441168,380736,848166,554319,93520,536691,373615,339937,924981,921241,634569,874110,218310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]