SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003541s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305081 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305081 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185210,530414,668664,642254,63425,820021,344292,368232,292806,70936,953801,65758,914994,580178,314229,422603,527222,984086,211205,22335,716967,542038,630567,668648,381662,56400,8042,61318,771192,1005338,129230,929888,877271,381604,510298,106191,210537,870395,145115,959678,949179,316534,675213,767773,721917,369737,937890,1001513,692979,941913,429072,85057,746148,295069,847890,312518,9963,931590,934461,794427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]