SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343399 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343399 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599107,81688,561579,252268,490491,258786,377964,987343,363796,735102,770111,269287,1025266,353643,1019911,224268,755881,235075,302939,657078,878209,18429,454450,919801,177343,392265,795575,171592,711500,867317,304306,15565,432737,155210,39683,492034,36871,16135,140432,258889,307973,574566,448722,478372,920622,5223,1027103,113497,883103,393795,610733,505517,549354,725033,531563,396618,617346,1000929,238030,619058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]