SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502528 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502528 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336306,135977,578705,502016,973796,159879,88869,606413,356491,436069,633644,1034484,987357,234168,737008,332225,298419,614745,355269,610375,1045384,905545,55470,934398,963866,493517,516223,875314,262957,202384,211414,909114,822185,467520,845279,70891,46056,27030,810865,503052,736049,420966,912882,86255,536597,317701,714205,154159,168440,69840,716855,1042167,647494,963079,292017,204992,822216,412612,565335,820342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000785s ]