SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555336 LIMIT 1 [ RunTime:0.001354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555336 [ RunTime:0.002905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028466,629037,786860,511790,1017047,24554,213230,33343,218998,19647,238945,872841,382166,225645,783094,154570,1027252,448856,883838,385355,685910,657007,962738,747483,706674,344844,888119,503533,111643,933199,423764,121392,203088,201297,776020,354320,297263,576447,604572,464332,133227,129323,829682,961262,699235,877476,100901,57315,793398,963323,416012,1034242,822585,214430,863043,93144,931894,642665,828748,716297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]