SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200482 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200482 [ RunTime:0.003190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69148,62148,464578,989811,833019,139882,411660,979488,933833,2286,466869,690433,152007,532717,847666,873304,664552,55951,49030,1037836,792986,717008,444860,304654,285513,842046,130835,457360,606533,257827,816279,445890,132306,414734,723731,211515,456035,769116,502478,937333,477579,204340,677586,509230,768336,404963,369837,912292,370929,968938,771186,37794,1026434,426178,761711,639342,875159,813314,94249,603432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]