SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013475 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013475 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127294,611744,164937,751013,597709,372017,606983,589441,223892,955350,37446,920914,510555,189252,797635,981256,915349,902183,492268,703263,258174,248850,938216,591203,810997,473583,348128,470552,752590,1035748,728641,842925,194931,45462,1472,165241,902993,785691,54706,802491,178929,83662,931724,606406,343212,823762,847244,865658,907223,156691,873877,674527,185900,720730,85860,103634,194026,596333,266653,734201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]