SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570927 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570927 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116310,345882,591929,691074,922413,579666,673409,883125,113770,91355,385049,917384,691319,86151,911150,921977,594583,696994,432661,351711,10116,51920,238965,931411,774694,212642,286625,824989,252059,450774,455213,297123,617146,903195,682308,999974,8226,531171,344735,155626,829421,300775,182793,632514,701512,743834,430909,148741,242451,828977,459507,336662,647379,123416,930854,633198,434136,843324,230276,107545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]