SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504059 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504059 [ RunTime:0.003732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010098,38237,88770,487272,611866,882461,98349,236748,1017340,841704,212357,724684,826637,829673,455213,518303,913784,807420,716977,511097,748759,433437,822432,330039,290447,133260,460161,381587,849055,422402,815826,826606,13044,1010693,371711,314380,224249,505724,100141,357888,112924,782882,523200,629733,197937,54018,26921,431983,118424,803357,542719,248180,540986,813816,1040727,72943,580300,254616,418669,861644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]