SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201152 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201152 [ RunTime:0.002449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140705,391655,856148,892145,134795,362946,858787,278553,723586,859453,657024,725546,765358,195134,906461,424857,933786,971511,110642,136059,105653,369378,1041940,300922,1033903,522813,230080,598329,1042292,579779,1015489,430671,278082,831027,126217,372241,216750,949265,757267,516946,778826,950429,960834,391227,734846,763246,358539,458097,783151,812163,874181,34440,842872,491003,87418,877484,237642,917694,328968,603787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]