SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461093 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461093 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107628,12296,474353,742482,935665,937109,515494,344800,431956,938652,353007,290487,388300,41132,960873,227867,677047,466254,807354,296975,1007153,97646,335564,283741,1048451,174517,677436,558758,828780,279168,955297,473068,912543,769676,968656,249180,301625,548343,1043556,428351,904712,374806,985452,146846,366114,154991,514274,788225,892855,468516,594321,968028,350651,132005,617124,404719,728736,185701,660324,1022425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]