SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691983 LIMIT 1 [ RunTime:0.000598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691983 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047022,610974,433653,446889,869721,290939,593305,571569,874050,889425,428005,598580,1035537,945655,903072,101058,649099,744600,215321,964601,535876,640541,157159,10464,248391,288974,5878,754286,771937,1030475,186921,314375,194538,614497,543422,492997,87019,4814,288629,154689,261155,152886,359361,951455,1015710,182314,922688,225264,621600,381342,85434,677166,896360,128420,599946,614909,793246,490260,1016486,758429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]